Tabela Insurance

Definicja tabeli Insurance

Name

Insurance

Code

Insurance

Comment

 


Lista kolumn tabeli Insurance

Name

Code

InsuranceID

InsuranceID

PermissionCodeID

PermissionCodeID

AdditionalPermissionID

AdditionalPermissionID

AdmCodeID

AdmCodeID

CountryID

CountryID

InsurerID

InsurerID

PermissionTitleID

PermissionTitleID

DocumentHolderPersonID

DocumentHolderPersonID

InstitutionCode

InstitutionCode

InstitutionShortName

InstitutionShortName

InstitutionCWU

InstitutionCWU

AddPermConfirmDocID

AddPermConfirmDocID

AddPermConfirmDocName

AddPermConfirmDocName

ExternalInsuranceID

ExternalInsuranceID

DOCUMENTNAME

DOCUMENTNAME

DOCUMENTNO

DOCUMENTNO

NPWZ

NPWZ

DOCUMENTDATE

DOCUMENTDATE

STARTDT

STARTDT

STOPDT

STOPDT

DOCUMENTISSUINGAUTHORITY

DOCUMENTISSUINGAUTHORITY

ISSUINGAUTHORITY

ISSUINGAUTHORITY

NFZINSURANCEID

NFZINSURANCEID


Kolumna InsuranceID tabeli Insurance

Definicja kolumny InsuranceID tabeli Insurance

Name

InsuranceID

Code

InsuranceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PermissionCodeID tabeli Insurance

Definicja kolumny PermissionCodeID tabeli Insurance

Name

PermissionCodeID

Code

PermissionCodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AdditionalPermissionID tabeli Insurance

Definicja kolumny AdditionalPermissionID tabeli Insurance

Name

AdditionalPermissionID

Code

AdditionalPermissionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AdmCodeID tabeli Insurance

Definicja kolumny AdmCodeID tabeli Insurance

Name

AdmCodeID

Code

AdmCodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CountryID tabeli Insurance

Definicja kolumny CountryID tabeli Insurance

Name

CountryID

Code

CountryID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsurerID tabeli Insurance

Definicja kolumny InsurerID tabeli Insurance

Name

InsurerID

Code

InsurerID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PermissionTitleID tabeli Insurance

Definicja kolumny PermissionTitleID tabeli Insurance

Name

PermissionTitleID

Code

PermissionTitleID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DocumentHolderPersonID tabeli Insurance

Definicja kolumny DocumentHolderPersonID tabeli Insurance

Name

DocumentHolderPersonID

Code

DocumentHolderPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InstitutionCode tabeli Insurance

Definicja kolumny InstitutionCode tabeli Insurance

Name

InstitutionCode

Code

InstitutionCode

Data Type

VARCHAR2(40)

Mandatory

No

Comment

 


Kolumna InstitutionShortName tabeli Insurance

Definicja kolumny InstitutionShortName tabeli Insurance

Name

InstitutionShortName

Code

InstitutionShortName

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna InstitutionCWU tabeli Insurance

Definicja kolumny InstitutionCWU tabeli Insurance

Name

InstitutionCWU

Code

InstitutionCWU

Data Type

VARCHAR2(120)

Mandatory

No

Comment

 


Kolumna AddPermConfirmDocID tabeli Insurance

Definicja kolumny AddPermConfirmDocID tabeli Insurance

Name

AddPermConfirmDocID

Code

AddPermConfirmDocID

Data Type

VARCHAR2(80)

Mandatory

No

Comment

 


Kolumna AddPermConfirmDocName tabeli Insurance

Definicja kolumny AddPermConfirmDocName tabeli Insurance

Name

AddPermConfirmDocName

Code

AddPermConfirmDocName

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna ExternalInsuranceID tabeli Insurance

Definicja kolumny ExternalInsuranceID tabeli Insurance

Name

ExternalInsuranceID

Code

ExternalInsuranceID

Data Type

VARCHAR2(80)

Mandatory

No

Comment

 


Kolumna DOCUMENTNAME tabeli Insurance

Definicja kolumny DOCUMENTNAME tabeli Insurance

Name

DOCUMENTNAME

Code

DOCUMENTNAME

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna DOCUMENTNO tabeli Insurance

Definicja kolumny DOCUMENTNO tabeli Insurance

Name

DOCUMENTNO

Code

DOCUMENTNO

Data Type

VARCHAR2(40)

Mandatory

No

Comment

 


Kolumna NPWZ tabeli Insurance

Definicja kolumny NPWZ tabeli Insurance

Name

NPWZ

Code

NPWZ

Data Type

VARCHAR2(8)

Mandatory

No

Comment

 


Kolumna DOCUMENTDATE tabeli Insurance

Definicja kolumny DOCUMENTDATE tabeli Insurance

Name

DOCUMENTDATE

Code

DOCUMENTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna STARTDT tabeli Insurance

Definicja kolumny STARTDT tabeli Insurance

Name

STARTDT

Code

STARTDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna STOPDT tabeli Insurance

Definicja kolumny STOPDT tabeli Insurance

Name

STOPDT

Code

STOPDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna DOCUMENTISSUINGAUTHORITY tabeli Insurance

Definicja kolumny DOCUMENTISSUINGAUTHORITY tabeli Insurance

Name

DOCUMENTISSUINGAUTHORITY

Code

DOCUMENTISSUINGAUTHORITY

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna ISSUINGAUTHORITY tabeli Insurance

Definicja kolumny ISSUINGAUTHORITY tabeli Insurance

Name

ISSUINGAUTHORITY

Code

ISSUINGAUTHORITY

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna NFZINSURANCEID tabeli Insurance

Definicja kolumny NFZINSURANCEID tabeli Insurance

Name

NFZINSURANCEID

Code

NFZINSURANCEID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli Insurance

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Insurance

Definicja klucza Identifier_1 tabeli Insurance

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment